package com.ldatum.crm.dao;

import java.sql.SQLException;
import java.util.List;

import com.ldatum.crm.domain.Member;

public interface MemberDao {

	int findTodayMembers() throws SQLException;

	int findBirthdayMembers() throws SQLException;

	int save(Member member) throws SQLException;

	Member queryById(int id)throws SQLException;

	List<Member> query(String cardno, String level, String name,
			String telephone)throws SQLException;

	int deletes(String ids)throws SQLException;

	int update(Member member)throws SQLException;

	List<Member> list() throws SQLException;

	Member findByCardno(String cardno) throws SQLException;

	boolean validationCardno(String cardno) throws SQLException;

	Member findById(int id) throws SQLException;

	int updateStatusToStoping(String ids) throws SQLException;

	int updateStatusToStart(String ids) throws SQLException;

	boolean validationCardnoOrTel(String cardnoOrTel) throws SQLException;

	boolean validationTel(String telephone) throws SQLException;

}
